A Church of Scotland minister has urged members of the Scottish Parliament to lead with a vision of hope that "inspires people to come together".